Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 576 |
| Missing cells | 1999 |
| Missing cells (%) | 18.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 85.6 KiB |
| Average record size in memory | 152.2 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 5 |
brand_name has a high cardinality: 105 distinct values | High cardinality |
generic_name has a high cardinality: 102 distinct values | High cardinality |
beneficiary_count_lis has a high cardinality: 275 distinct values | High cardinality |
beneficiary_count_no_lis has a high cardinality: 274 distinct values | High cardinality |
total_spending is highly overall correlated with beneficiary_cost_share and 6 other fields | High correlation |
beneficiary_count is highly overall correlated with unit_count and 4 other fields | High correlation |
unit_count is highly overall correlated with beneficiary_count and 3 other fields | High correlation |
beneficiary_cost_share is highly overall correlated with total_spending and 4 other fields | High correlation |
total_annual_spending_per_user is highly overall correlated with total_spending and 4 other fields | High correlation |
average_cost_per_unit is highly overall correlated with total_annual_spending_per_user and 2 other fields | High correlation |
average_annual_beneficiary_cost_share is highly overall correlated with total_spending and 4 other fields | High correlation |
claim_count is highly overall correlated with beneficiary_count and 3 other fields | High correlation |
beneficiary_cost_share_lis is highly overall correlated with total_spending and 6 other fields | High correlation |
beneficiary_cost_share_no_lis is highly overall correlated with total_spending and 7 other fields | High correlation |
average_beneficiary_cost_share_lis is highly overall correlated with total_spending and 6 other fields | High correlation |
average_beneficiary_cost_share_no_lis is highly overall correlated with total_spending and 4 other fields | High correlation |
coverage_type is highly overall correlated with average_annual_beneficiary_cost_share and 4 other fields | High correlation |
average_annual_beneficiary_cost_share has 307 (53.3%) missing values | Missing |
beneficiary_count_lis has 282 (49.0%) missing values | Missing |
beneficiary_count_no_lis has 282 (49.0%) missing values | Missing |
beneficiary_cost_share_lis has 282 (49.0%) missing values | Missing |
beneficiary_cost_share_no_lis has 282 (49.0%) missing values | Missing |
average_beneficiary_cost_share_lis has 282 (49.0%) missing values | Missing |
average_beneficiary_cost_share_no_lis has 282 (49.0%) missing values | Missing |
brand_name is uniformly distributed | Uniform |
generic_name is uniformly distributed | Uniform |
serialid is uniformly distributed | Uniform |
serialid has unique values | Unique |
total_spending has 37 (6.4%) zeros | Zeros |
beneficiary_count has 37 (6.4%) zeros | Zeros |
unit_count has 37 (6.4%) zeros | Zeros |
beneficiary_cost_share has 42 (7.3%) zeros | Zeros |
total_annual_spending_per_user has 37 (6.4%) zeros | Zeros |
average_cost_per_unit has 37 (6.4%) zeros | Zeros |
average_annual_beneficiary_cost_share has 10 (1.7%) zeros | Zeros |
claim_count has 37 (6.4%) zeros | Zeros |
beneficiary_cost_share_lis has 19 (3.3%) zeros | Zeros |
beneficiary_cost_share_no_lis has 19 (3.3%) zeros | Zeros |
average_beneficiary_cost_share_lis has 19 (3.3%) zeros | Zeros |
average_beneficiary_cost_share_no_lis has 19 (3.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-18 19:22:00.148500 |
|---|---|
| Analysis finished | 2023-09-18 19:22:36.702231 |
| Duration | 36.55 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
year
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.5 |
| Minimum | 2010 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2010 |
| Q1 | 2011 |
| median | 2012.5 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6258777 |
|---|---|
| Coefficient of variation (CV) | 0.00080788954 |
| Kurtosis | -1.1758501 |
| Mean | 2012.5 |
| Median Absolute Deviation (MAD) | 1.5 |
| Skewness | 0 |
| Sum | 1159200 |
| Variance | 2.6434783 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2011 | 104 | |
| 2012 | 104 | |
| 2013 | 104 | |
| 2014 | 104 | |
| 2010 | 80 | |
| 2015 | 80 |
| Value | Count | Frequency (%) |
| 2010 | 80 | |
| 2011 | 104 | |
| 2012 | 104 | |
| 2013 | 104 | |
| 2014 | 104 | |
| 2015 | 80 |
| Value | Count | Frequency (%) |
| 2015 | 80 | |
| 2014 | 104 | |
| 2013 | 104 | |
| 2012 | 104 | |
| 2011 | 104 | |
| 2010 | 80 |
brand_name
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 105 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 KiB |
| Depo-Medrol; Methylprednisolone Acetate | 10 |
|---|---|
| Abilify | 6 |
| Lucentis | 6 |
| Prezista | 6 |
| Perforomist | 6 |
| Other values (100) |
Length
| Max length | 39 |
|---|---|
| Median length | 32 |
| Mean length | 11.454861 |
| Min length | 5 |
Characters and Unicode
| Total characters | 6598 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Abilify |
|---|---|
| 2nd row | Abilify |
| 3rd row | Abilify |
| 4th row | Abilify |
| 5th row | Abilify |
Common Values
| Value | Count | Frequency (%) |
| Depo-Medrol; Methylprednisolone Acetate | 10 | 1.7% |
| Abilify | 6 | 1.0% |
| Lucentis | 6 | 1.0% |
| Prezista | 6 | 1.0% |
| Perforomist | 6 | 1.0% |
| Orencia | 6 | 1.0% |
| Nexium | 6 | 1.0% |
| Neulasta | 6 | 1.0% |
| Lyrica | 6 | 1.0% |
| Letairis | 6 | 1.0% |
| Other values (95) | 512 |
Length
| Value | Count | Frequency (%) |
| hcl | 25 | 3.0% |
| acetate | 15 | 1.8% |
| lar | 15 | 1.8% |
| sandostatin | 15 | 1.8% |
| lantus | 12 | 1.5% |
| depo-medrol | 10 | 1.2% |
| activase | 10 | 1.2% |
| sulfate | 10 | 1.2% |
| methylprednisolone | 10 | 1.2% |
| humira | 7 | 0.9% |
| Other values (126) | 692 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 642 | 9.7% |
| e | 594 | 9.0% |
| i | 514 | 7.8% |
| o | 415 | 6.3% |
| n | 400 | 6.1% |
| r | 396 | 6.0% |
| t | 344 | 5.2% |
| l | 335 | 5.1% |
| 245 | 3.7% | |
| s | 206 | 3.1% |
| Other values (46) | 2507 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5344 | |
| Uppercase Letter | 892 | 13.5% |
| Space Separator | 245 | 3.7% |
| Other Punctuation | 91 | 1.4% |
| Dash Punctuation | 16 | 0.2% |
| Decimal Number | 10 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 642 | |
| e | 594 | |
| i | 514 | 9.6% |
| o | 415 | 7.8% |
| n | 400 | 7.5% |
| r | 396 | 7.4% |
| t | 344 | 6.4% |
| l | 335 | 6.3% |
| s | 206 | 3.9% |
| c | 189 | 3.5% |
| Other values (15) | 1309 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 107 | |
| C | 95 | 10.7% |
| P | 67 | 7.5% |
| H | 60 | 6.7% |
| S | 59 | 6.6% |
| G | 57 | 6.4% |
| L | 56 | 6.3% |
| T | 51 | 5.7% |
| R | 49 | 5.5% |
| D | 46 | 5.2% |
| Other values (15) | 245 |
Other Punctuation
| Value | Count | Frequency (%) |
| ; | 81 | |
| . | 10 | 11.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 5 | |
| 3 | 5 |
Space Separator
| Value | Count | Frequency (%) |
| 245 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6236 | |
| Common | 362 | 5.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 642 | 10.3% |
| e | 594 | 9.5% |
| i | 514 | 8.2% |
| o | 415 | 6.7% |
| n | 400 | 6.4% |
| r | 396 | 6.4% |
| t | 344 | 5.5% |
| l | 335 | 5.4% |
| s | 206 | 3.3% |
| c | 189 | 3.0% |
| Other values (40) | 2201 |
Common
| Value | Count | Frequency (%) |
| 245 | ||
| ; | 81 | 22.4% |
| - | 16 | 4.4% |
| . | 10 | 2.8% |
| 1 | 5 | 1.4% |
| 3 | 5 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6598 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 642 | 9.7% |
| e | 594 | 9.0% |
| i | 514 | 7.8% |
| o | 415 | 6.3% |
| n | 400 | 6.1% |
| r | 396 | 6.0% |
| t | 344 | 5.2% |
| l | 335 | 5.1% |
| 245 | 3.7% | |
| s | 206 | 3.1% |
| Other values (46) | 2507 |
generic_name
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 102 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 KiB |
| Immun Glob G(IGG)/Pro/Iga 0-50 | 12 |
|---|---|
| Immun Glob G (IGG)/Gly/Iga 50+ | 12 |
| Insulin Glargine,Hum.Rec.Anlog | 11 |
| Aripiprazole | 6 |
| Ambrisentan | 6 |
| Other values (97) |
Length
| Max length | 74 |
|---|---|
| Median length | 26 |
| Mean length | 17.824653 |
| Min length | 7 |
Characters and Unicode
| Total characters | 10267 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Aripiprazole |
|---|---|
| 2nd row | Aripiprazole |
| 3rd row | Aripiprazole |
| 4th row | Aripiprazole |
| 5th row | Aripiprazole |
Common Values
| Value | Count | Frequency (%) |
| Immun Glob G(IGG)/Pro/Iga 0-50 | 12 | 2.1% |
| Immun Glob G (IGG)/Gly/Iga 50+ | 12 | 2.1% |
| Insulin Glargine,Hum.Rec.Anlog | 11 | 1.9% |
| Aripiprazole | 6 | 1.0% |
| Ambrisentan | 6 | 1.0% |
| Formoterol Fumarate | 6 | 1.0% |
| Abatacept; Abatacept/Maltose | 6 | 1.0% |
| Esomeprazole Magnesium | 6 | 1.0% |
| Pegfilgrastim | 6 | 1.0% |
| Pregabalin | 6 | 1.0% |
| Other values (92) | 499 |
Length
| Value | Count | Frequency (%) |
| hcl | 57 | 5.5% |
| acetate | 32 | 3.1% |
| glob | 29 | 2.8% |
| immun | 29 | 2.8% |
| sodium | 21 | 2.0% |
| 50 | 17 | 1.6% |
| alfa | 16 | 1.6% |
| g | 12 | 1.2% |
| igg)/gly/iga | 12 | 1.2% |
| treprostinil | 12 | 1.2% |
| Other values (133) | 794 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 856 | 8.3% |
| i | 820 | 8.0% |
| a | 810 | 7.9% |
| o | 677 | 6.6% |
| t | 628 | 6.1% |
| l | 590 | 5.7% |
| r | 566 | 5.5% |
| n | 531 | 5.2% |
| 455 | 4.4% | |
| m | 453 | 4.4% |
| Other values (48) | 3881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8080 | |
| Uppercase Letter | 1288 | 12.5% |
| Space Separator | 455 | 4.4% |
| Other Punctuation | 185 | 1.8% |
| Decimal Number | 112 | 1.1% |
| Open Punctuation | 45 | 0.4% |
| Close Punctuation | 45 | 0.4% |
| Dash Punctuation | 40 | 0.4% |
| Math Symbol | 17 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 856 | |
| i | 820 | |
| a | 810 | |
| o | 677 | 8.4% |
| t | 628 | 7.8% |
| l | 590 | 7.3% |
| r | 566 | 7.0% |
| n | 531 | 6.6% |
| m | 453 | 5.6% |
| u | 324 | 4.0% |
| Other values (13) | 1825 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 156 | |
| A | 145 | |
| I | 127 | |
| C | 126 | |
| P | 98 | 7.6% |
| S | 76 | 5.9% |
| H | 73 | 5.7% |
| E | 73 | 5.7% |
| T | 70 | 5.4% |
| M | 63 | 4.9% |
| Other values (9) | 281 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 51 | |
| 5 | 29 | |
| 1 | 11 | 9.8% |
| 2 | 6 | 5.4% |
| 8 | 5 | 4.5% |
| 4 | 5 | 4.5% |
| 3 | 5 | 4.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 123 | |
| . | 22 | 11.9% |
| , | 22 | 11.9% |
| ; | 18 | 9.7% |
Space Separator
| Value | Count | Frequency (%) |
| 455 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 45 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 45 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 40 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 17 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9368 | |
| Common | 899 | 8.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 856 | 9.1% |
| i | 820 | 8.8% |
| a | 810 | 8.6% |
| o | 677 | 7.2% |
| t | 628 | 6.7% |
| l | 590 | 6.3% |
| r | 566 | 6.0% |
| n | 531 | 5.7% |
| m | 453 | 4.8% |
| u | 324 | 3.5% |
| Other values (32) | 3113 |
Common
| Value | Count | Frequency (%) |
| 455 | ||
| / | 123 | 13.7% |
| 0 | 51 | 5.7% |
| ( | 45 | 5.0% |
| ) | 45 | 5.0% |
| - | 40 | 4.4% |
| 5 | 29 | 3.2% |
| . | 22 | 2.4% |
| , | 22 | 2.4% |
| ; | 18 | 2.0% |
| Other values (6) | 49 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10267 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 856 | 8.3% |
| i | 820 | 8.0% |
| a | 810 | 7.9% |
| o | 677 | 6.6% |
| t | 628 | 6.1% |
| l | 590 | 5.7% |
| r | 566 | 5.5% |
| n | 531 | 5.2% |
| 455 | 4.4% | |
| m | 453 | 4.4% |
| Other values (48) | 3881 |
coverage_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 KiB |
| Part D | |
|---|---|
| Part B |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 3456 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Part D |
|---|---|
| 2nd row | Part D |
| 3rd row | Part D |
| 4th row | Part D |
| 5th row | Part D |
Common Values
| Value | Count | Frequency (%) |
| Part D | 296 | |
| Part B | 280 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| part | 576 | |
| d | 296 | |
| b | 280 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 576 | |
| a | 576 | |
| r | 576 | |
| t | 576 | |
| 576 | ||
| D | 296 | |
| B | 280 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1728 | |
| Uppercase Letter | 1152 | |
| Space Separator | 576 | 16.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 576 | |
| D | 296 | |
| B | 280 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 576 | |
| r | 576 | |
| t | 576 |
Space Separator
| Value | Count | Frequency (%) |
| 576 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2880 | |
| Common | 576 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 576 | |
| a | 576 | |
| r | 576 | |
| t | 576 | |
| D | 296 | |
| B | 280 |
Common
| Value | Count | Frequency (%) |
| 576 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3456 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 576 | |
| a | 576 | |
| r | 576 | |
| t | 576 | |
| 576 | ||
| D | 296 | |
| B | 280 |
total_spending
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 537 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4227844 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 7.0306335 × 109 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 34557234 |
| median | 1.9942845 × 108 |
| Q3 | 5.3967443 × 108 |
| 95-th percentile | 1.7337103 × 109 |
| Maximum | 7.0306335 × 109 |
| Range | 7.0306335 × 109 |
| Interquartile range (IQR) | 5.0511719 × 108 |
Descriptive statistics
| Standard deviation | 6.5057385 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.4709599 |
| Kurtosis | 21.306611 |
| Mean | 4.4227844 × 108 |
| Median Absolute Deviation (MAD) | 1.8736281 × 108 |
| Skewness | 3.3784316 |
| Sum | 2.5475238 × 1011 |
| Variance | 4.2324633 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 303563688.7 | 2 | 0.3% |
| 275984353.3 | 2 | 0.3% |
| 234803146 | 2 | 0.3% |
| 1225884701 | 1 | 0.2% |
| 62533673.24 | 1 | 0.2% |
| 34647375.24 | 1 | 0.2% |
| 40143407.22 | 1 | 0.2% |
| 47622607.16 | 1 | 0.2% |
| 54257433.85 | 1 | 0.2% |
| Other values (527) | 527 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 104626.93 | 1 | 0.2% |
| 630784.32 | 1 | 0.2% |
| 1039890.46 | 1 | 0.2% |
| 1084689.44 | 1 | 0.2% |
| 1293081.32 | 1 | 0.2% |
| 1352432.82 | 1 | 0.2% |
| 1563550.5 | 1 | 0.2% |
| 1571232.83 | 1 | 0.2% |
| 3042836.26 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 7030633486 | 1 | |
| 4359504167 | 1 | |
| 3106960981 | 1 | |
| 2883122484 | 1 | |
| 2660421777 | 1 | |
| 2543786426 | 1 | |
| 2527319032 | 1 | |
| 2526306069 | 1 | |
| 2276374749 | 1 | |
| 2270015726 | 1 |
beneficiary_count
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 536 |
|---|---|
| Distinct (%) | 93.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 218741.39 |
| Minimum | 0 |
|---|---|
| Maximum | 5698568 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 8639.75 |
| median | 26758 |
| Q3 | 171911.75 |
| 95-th percentile | 1133103.2 |
| Maximum | 5698568 |
| Range | 5698568 |
| Interquartile range (IQR) | 163272 |
Descriptive statistics
| Standard deviation | 441777 |
|---|---|
| Coefficient of variation (CV) | 2.0196315 |
| Kurtosis | 42.128881 |
| Mean | 218741.39 |
| Median Absolute Deviation (MAD) | 24801.5 |
| Skewness | 4.6244726 |
| Sum | 1.2599504 × 108 |
| Variance | 1.9516692 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 9336 | 3 | 0.5% |
| 10144 | 2 | 0.3% |
| 9790 | 2 | 0.3% |
| 31687 | 1 | 0.2% |
| 13678 | 1 | 0.2% |
| 12804 | 1 | 0.2% |
| 28423 | 1 | 0.2% |
| 31558 | 1 | 0.2% |
| 28204 | 1 | 0.2% |
| Other values (526) | 526 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 65 | 1 | 0.2% |
| 330 | 1 | 0.2% |
| 475 | 1 | 0.2% |
| 482 | 1 | 0.2% |
| 533 | 1 | 0.2% |
| 569 | 1 | 0.2% |
| 643 | 1 | 0.2% |
| 743 | 1 | 0.2% |
| 829 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 5698568 | 1 | |
| 1752704 | 1 | |
| 1733071 | 1 | |
| 1732787 | 1 | |
| 1673911 | 1 | |
| 1598181 | 1 | |
| 1556034 | 1 | |
| 1527217 | 1 | |
| 1516292 | 1 | |
| 1496093 | 1 |
unit_count
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 537 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48747854 |
| Minimum | 0 |
|---|---|
| Maximum | 4.9296252 × 108 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1496759.8 |
| median | 5723160.5 |
| Q3 | 29186222 |
| 95-th percentile | 3.1085136 × 108 |
| Maximum | 4.9296252 × 108 |
| Range | 4.9296252 × 108 |
| Interquartile range (IQR) | 27689462 |
Descriptive statistics
| Standard deviation | 97253161 |
|---|---|
| Coefficient of variation (CV) | 1.9950245 |
| Kurtosis | 5.8611396 |
| Mean | 48747854 |
| Median Absolute Deviation (MAD) | 5627013 |
| Skewness | 2.5273143 |
| Sum | 2.8078764 × 1010 |
| Variance | 9.4581773 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 2316230 | 2 | 0.3% |
| 2240840 | 2 | 0.3% |
| 2017851 | 2 | 0.3% |
| 71848190 | 1 | 0.2% |
| 10760804 | 1 | 0.2% |
| 3051652 | 1 | 0.2% |
| 8649840 | 1 | 0.2% |
| 10072377 | 1 | 0.2% |
| 10758166 | 1 | 0.2% |
| Other values (527) | 527 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 1988 | 1 | 0.2% |
| 2737 | 1 | 0.2% |
| 4853 | 1 | 0.2% |
| 5125 | 1 | 0.2% |
| 5536 | 1 | 0.2% |
| 6333 | 1 | 0.2% |
| 6666 | 1 | 0.2% |
| 7829 | 1 | 0.2% |
| 9325 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 492962520 | 1 | |
| 460372139 | 1 | |
| 456213793 | 1 | |
| 452555226 | 1 | |
| 448605068 | 1 | |
| 436743044 | 1 | |
| 430415878 | 1 | |
| 429548239 | 1 | |
| 423148377 | 1 | |
| 419224451 | 1 |
beneficiary_cost_share
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 532 |
|---|---|
| Distinct (%) | 92.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50261013 |
| Minimum | 0 |
|---|---|
| Maximum | 3.9106178 × 108 |
| Zeros | 42 |
| Zeros (%) | 7.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3365941.9 |
| median | 22056618 |
| Q3 | 54989956 |
| 95-th percentile | 2.165789 × 108 |
| Maximum | 3.9106178 × 108 |
| Range | 3.9106178 × 108 |
| Interquartile range (IQR) | 51624014 |
Descriptive statistics
| Standard deviation | 72825364 |
|---|---|
| Coefficient of variation (CV) | 1.4489434 |
| Kurtosis | 4.3647582 |
| Mean | 50261013 |
| Median Absolute Deviation (MAD) | 20201756 |
| Skewness | 2.1354517 |
| Sum | 2.8950343 × 1010 |
| Variance | 5.3035336 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 42 | 7.3% |
| 46824924.09 | 2 | 0.3% |
| 60866329.06 | 2 | 0.3% |
| 54778931.51 | 2 | 0.3% |
| 10097210.56 | 1 | 0.2% |
| 992662.12 | 1 | 0.2% |
| 712351.44 | 1 | 0.2% |
| 680763.1 | 1 | 0.2% |
| 8466333.24 | 1 | 0.2% |
| 38186677.97 | 1 | 0.2% |
| Other values (522) | 522 |
| Value | Count | Frequency (%) |
| 0 | 42 | |
| 30434.69 | 1 | 0.2% |
| 33864.07 | 1 | 0.2% |
| 233476.65 | 1 | 0.2% |
| 267447.16 | 1 | 0.2% |
| 274701.47 | 1 | 0.2% |
| 275398.22 | 1 | 0.2% |
| 375288.2 | 1 | 0.2% |
| 385473.14 | 1 | 0.2% |
| 410124.45 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 391061781.2 | 1 | |
| 388902182.1 | 1 | |
| 370196109.4 | 1 | |
| 369502754.2 | 1 | |
| 347673799.6 | 1 | |
| 299402108.4 | 1 | |
| 292242339.6 | 1 | |
| 290093486.2 | 1 | |
| 286693327 | 1 | |
| 286537261.5 | 1 |
total_annual_spending_per_user
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 536 |
|---|---|
| Distinct (%) | 93.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16635.697 |
| Minimum | 0 |
|---|---|
| Maximum | 162370.93 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 442.22 |
| median | 5640.76 |
| Q3 | 21529.178 |
| 95-th percentile | 71946.902 |
| Maximum | 162370.93 |
| Range | 162370.93 |
| Interquartile range (IQR) | 21086.958 |
Descriptive statistics
| Standard deviation | 25960.796 |
|---|---|
| Coefficient of variation (CV) | 1.5605476 |
| Kurtosis | 8.1891778 |
| Mean | 16635.697 |
| Median Absolute Deviation (MAD) | 5617.08 |
| Skewness | 2.6507178 |
| Sum | 9582161.3 |
| Variance | 6.7396294 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 58.25 | 2 | 0.3% |
| 29925.44 | 2 | 0.3% |
| 28190.43 | 2 | 0.3% |
| 25150.29 | 2 | 0.3% |
| 2062.8 | 1 | 0.2% |
| 2705.98 | 1 | 0.2% |
| 1412.36 | 1 | 0.2% |
| 1509.05 | 1 | 0.2% |
| 1712.29 | 1 | 0.2% |
| Other values (526) | 526 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 1.58 | 1 | 0.2% |
| 1.69 | 1 | 0.2% |
| 2.35 | 1 | 0.2% |
| 4.77 | 1 | 0.2% |
| 6.03 | 1 | 0.2% |
| 6.23 | 1 | 0.2% |
| 6.56 | 1 | 0.2% |
| 7.61 | 1 | 0.2% |
| 7.91 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 162370.93 | 1 | |
| 145481.62 | 1 | |
| 144069.54 | 1 | |
| 141673.75 | 1 | |
| 141147.79 | 1 | |
| 140734.52 | 1 | |
| 133844.66 | 1 | |
| 133420.75 | 1 | |
| 108013.82 | 1 | |
| 107489.13 | 1 |
average_cost_per_unit
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 498 |
|---|---|
| Distinct (%) | 86.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 513.87167 |
| Minimum | 0 |
|---|---|
| Maximum | 35205.98 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.635 |
| median | 20.475 |
| Q3 | 93.2725 |
| 95-th percentile | 1131.0175 |
| Maximum | 35205.98 |
| Range | 35205.98 |
| Interquartile range (IQR) | 89.6375 |
Descriptive statistics
| Standard deviation | 3170.4312 |
|---|---|
| Coefficient of variation (CV) | 6.1696945 |
| Kurtosis | 99.444899 |
| Mean | 513.87167 |
| Median Absolute Deviation (MAD) | 20.205 |
| Skewness | 9.8306915 |
| Sum | 295990.08 |
| Variance | 10051634 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 0.64 | 3 | 0.5% |
| 0.33 | 3 | 0.5% |
| 0.12 | 3 | 0.5% |
| 0.06 | 3 | 0.5% |
| 0.2 | 3 | 0.5% |
| 0.16 | 3 | 0.5% |
| 0.43 | 3 | 0.5% |
| 0.52 | 2 | 0.3% |
| 8.02 | 2 | 0.3% |
| Other values (488) | 514 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 0.05 | 2 | 0.3% |
| 0.06 | 3 | 0.5% |
| 0.08 | 1 | 0.2% |
| 0.09 | 2 | 0.3% |
| 0.11 | 2 | 0.3% |
| 0.12 | 3 | 0.5% |
| 0.13 | 1 | 0.2% |
| 0.16 | 3 | 0.5% |
| 0.17 | 2 | 0.3% |
| Value | Count | Frequency (%) |
| 35205.98 | 1 | |
| 33865.51 | 1 | |
| 32857.47 | 1 | |
| 32775.67 | 1 | |
| 32301.81 | 1 | |
| 6827.41 | 1 | |
| 6497.74 | 1 | |
| 6158.54 | 1 | |
| 5977.25 | 1 | |
| 5303.69 | 1 |
average_annual_beneficiary_cost_share
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 257 |
|---|---|
| Distinct (%) | 95.5% |
| Missing | 307 |
| Missing (%) | 53.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3676.3968 |
| Minimum | 0 |
|---|---|
| Maximum | 29287.8 |
| Zeros | 10 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.258 |
| Q1 | 403.31 |
| median | 2420.28 |
| Q3 | 4493.4 |
| 95-th percentile | 13575.646 |
| Maximum | 29287.8 |
| Range | 29287.8 |
| Interquartile range (IQR) | 4090.09 |
Descriptive statistics
| Standard deviation | 5202.5846 |
|---|---|
| Coefficient of variation (CV) | 1.4151314 |
| Kurtosis | 10.787407 |
| Mean | 3676.3968 |
| Median Absolute Deviation (MAD) | 2056.38 |
| Skewness | 3.0378041 |
| Sum | 988950.74 |
| Variance | 27066886 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10 | 1.7% |
| 6000.23 | 2 | 0.3% |
| 5595.4 | 2 | 0.3% |
| 5015.52 | 2 | 0.3% |
| 2998.88 | 1 | 0.2% |
| 2664.84 | 1 | 0.2% |
| 2847.92 | 1 | 0.2% |
| 3470.05 | 1 | 0.2% |
| 4368.86 | 1 | 0.2% |
| 297.87 | 1 | 0.2% |
| Other values (247) | 247 | |
| (Missing) | 307 |
| Value | Count | Frequency (%) |
| 0 | 10 | |
| 0.41 | 1 | 0.2% |
| 0.43 | 1 | 0.2% |
| 0.64 | 1 | 0.2% |
| 1.13 | 1 | 0.2% |
| 1.45 | 1 | 0.2% |
| 1.48 | 1 | 0.2% |
| 1.54 | 1 | 0.2% |
| 1.74 | 1 | 0.2% |
| 1.86 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 29287.8 | 1 | |
| 29107.73 | 1 | |
| 28659.52 | 1 | |
| 28236.3 | 1 | |
| 28151.88 | 1 | |
| 27192.12 | 1 | |
| 21863.51 | 1 | |
| 20240.43 | 1 | |
| 19295.76 | 1 | |
| 17553.24 | 1 |
claim_count
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 537 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 967023.18 |
| Minimum | 0 |
|---|---|
| Maximum | 9073952 |
| Zeros | 37 |
| Zeros (%) | 6.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 54981.75 |
| median | 162238 |
| Q3 | 727304.75 |
| 95-th percentile | 5320156.2 |
| Maximum | 9073952 |
| Range | 9073952 |
| Interquartile range (IQR) | 672323 |
Descriptive statistics
| Standard deviation | 1811337.1 |
|---|---|
| Coefficient of variation (CV) | 1.8731061 |
| Kurtosis | 5.7301852 |
| Mean | 967023.18 |
| Median Absolute Deviation (MAD) | 151537.5 |
| Skewness | 2.4753407 |
| Sum | 5.5700535 × 108 |
| Variance | 3.280942 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37 | 6.4% |
| 79626 | 2 | 0.3% |
| 77085 | 2 | 0.3% |
| 70070 | 2 | 0.3% |
| 2296081 | 1 | 0.2% |
| 180067 | 1 | 0.2% |
| 23506 | 1 | 0.2% |
| 145479 | 1 | 0.2% |
| 169474 | 1 | 0.2% |
| 180799 | 1 | 0.2% |
| Other values (527) | 527 |
| Value | Count | Frequency (%) |
| 0 | 37 | |
| 65 | 1 | 0.2% |
| 412 | 1 | 0.2% |
| 483 | 1 | 0.2% |
| 1215 | 1 | 0.2% |
| 1471 | 1 | 0.2% |
| 1814 | 1 | 0.2% |
| 2620 | 1 | 0.2% |
| 2733 | 1 | 0.2% |
| 2996 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 9073952 | 1 | |
| 9066409 | 1 | |
| 8855330 | 1 | |
| 8712212 | 1 | |
| 8624570 | 1 | |
| 8488726 | 1 | |
| 8223984 | 1 | |
| 8192362 | 1 | |
| 7912220 | 1 | |
| 7826825 | 1 |
beneficiary_count_lis
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 275 |
|---|---|
| Distinct (%) | 93.5% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Memory size | 4.6 KiB |
| 0 | 19 |
|---|---|
| 184 | 2 |
| 287,370 | 1 |
| 833,933 | 1 |
| 8,128 | 1 |
| Other values (270) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.6802721 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1670 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 273 ? |
|---|---|
| Unique (%) | 92.9% |
Sample
| 1st row | 287,370 |
|---|---|
| 2nd row | 303,264 |
| 3rd row | 310,592 |
| 4th row | 317,698 |
| 5th row | 326,791 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 184 | 2 | 0.3% |
| 287,370 | 1 | 0.2% |
| 833,933 | 1 | 0.2% |
| 8,128 | 1 | 0.2% |
| 7,877 | 1 | 0.2% |
| 37 | 1 | 0.2% |
| 704,238 | 1 | 0.2% |
| 795,701 | 1 | 0.2% |
| 866,303 | 1 | 0.2% |
| Other values (265) | 265 | |
| (Missing) | 282 |
Length
| Value | Count | Frequency (%) |
| 0 | 19 | 6.5% |
| 184 | 2 | 0.7% |
| 4,557 | 1 | 0.3% |
| 745,678 | 1 | 0.3% |
| 620 | 1 | 0.3% |
| 606,135 | 1 | 0.3% |
| 668,600 | 1 | 0.3% |
| 734,070 | 1 | 0.3% |
| 736,590 | 1 | 0.3% |
| 737,603 | 1 | 0.3% |
| Other values (265) | 265 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 261 | |
| 3 | 181 | |
| 1 | 180 | |
| 2 | 171 | |
| 0 | 132 | |
| 4 | 132 | |
| 7 | 129 | |
| 5 | 128 | |
| 6 | 128 | |
| 9 | 117 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1409 | |
| Other Punctuation | 261 | 15.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 181 | |
| 1 | 180 | |
| 2 | 171 | |
| 0 | 132 | |
| 4 | 132 | |
| 7 | 129 | |
| 5 | 128 | |
| 6 | 128 | |
| 9 | 117 | |
| 8 | 111 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 261 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1670 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| , | 261 | |
| 3 | 181 | |
| 1 | 180 | |
| 2 | 171 | |
| 0 | 132 | |
| 4 | 132 | |
| 7 | 129 | |
| 5 | 128 | |
| 6 | 128 | |
| 9 | 117 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1670 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| , | 261 | |
| 3 | 181 | |
| 1 | 180 | |
| 2 | 171 | |
| 0 | 132 | |
| 4 | 132 | |
| 7 | 129 | |
| 5 | 128 | |
| 6 | 128 | |
| 9 | 117 |
beneficiary_count_no_lis
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 274 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Memory size | 4.6 KiB |
| 0 | 19 |
|---|---|
| 6,462 | 2 |
| 6,252 | 2 |
| 51,256 | 1 |
| 650,078 | 1 |
| Other values (269) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 5.5782313 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1640 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 271 ? |
|---|---|
| Unique (%) | 92.2% |
Sample
| 1st row | 51,256 |
|---|---|
| 2nd row | 57,406 |
| 3rd row | 66,009 |
| 4th row | 79,066 |
| 5th row | 78,369 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 6,462 | 2 | 0.3% |
| 6,252 | 2 | 0.3% |
| 51,256 | 1 | 0.2% |
| 650,078 | 1 | 0.2% |
| 4,769 | 1 | 0.2% |
| 28 | 1 | 0.2% |
| 423,708 | 1 | 0.2% |
| 610,098 | 1 | 0.2% |
| 556,827 | 1 | 0.2% |
| Other values (264) | 264 | |
| (Missing) | 282 |
Length
| Value | Count | Frequency (%) |
| 0 | 19 | 6.5% |
| 6,252 | 2 | 0.7% |
| 6,462 | 2 | 0.7% |
| 6,548 | 1 | 0.3% |
| 5,000 | 1 | 0.3% |
| 51,726 | 1 | 0.3% |
| 5,072 | 1 | 0.3% |
| 66,009 | 1 | 0.3% |
| 79,066 | 1 | 0.3% |
| 78,369 | 1 | 0.3% |
| Other values (264) | 264 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 265 | |
| 4 | 158 | |
| 6 | 154 | |
| 1 | 148 | |
| 3 | 147 | |
| 0 | 143 | |
| 5 | 143 | |
| 2 | 142 | |
| 8 | 124 | |
| 9 | 120 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1375 | |
| Other Punctuation | 265 | 16.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 158 | |
| 6 | 154 | |
| 1 | 148 | |
| 3 | 147 | |
| 0 | 143 | |
| 5 | 143 | |
| 2 | 142 | |
| 8 | 124 | |
| 9 | 120 | |
| 7 | 96 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 265 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1640 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| , | 265 | |
| 4 | 158 | |
| 6 | 154 | |
| 1 | 148 | |
| 3 | 147 | |
| 0 | 143 | |
| 5 | 143 | |
| 2 | 142 | |
| 8 | 124 | |
| 9 | 120 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1640 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| , | 265 | |
| 4 | 158 | |
| 6 | 154 | |
| 1 | 148 | |
| 3 | 147 | |
| 0 | 143 | |
| 5 | 143 | |
| 2 | 142 | |
| 8 | 124 | |
| 9 | 120 |
beneficiary_cost_share_lis
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 276 |
|---|---|
| Distinct (%) | 93.9% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2791453.5 |
| Minimum | 0 |
|---|---|
| Maximum | 24982823 |
| Zeros | 19 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 216766.93 |
| median | 626085.41 |
| Q3 | 1722618.9 |
| 95-th percentile | 14304288 |
| Maximum | 24982823 |
| Range | 24982823 |
| Interquartile range (IQR) | 1505852 |
Descriptive statistics
| Standard deviation | 4805260.3 |
|---|---|
| Coefficient of variation (CV) | 1.7214187 |
| Kurtosis | 4.4272993 |
| Mean | 2791453.5 |
| Median Absolute Deviation (MAD) | 525587.45 |
| Skewness | 2.1996712 |
| Sum | 8.2068734 × 108 |
| Variance | 2.3090526 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 6931345.55 | 1 | 0.2% |
| 17249020.38 | 1 | 0.2% |
| 77166.52 | 1 | 0.2% |
| 160794.65 | 1 | 0.2% |
| 47916.72 | 1 | 0.2% |
| 311872.21 | 1 | 0.2% |
| 33.8 | 1 | 0.2% |
| 9947779.77 | 1 | 0.2% |
| 19885808.24 | 1 | 0.2% |
| Other values (266) | 266 | |
| (Missing) | 282 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 33.8 | 1 | 0.2% |
| 178.7 | 1 | 0.2% |
| 2566.24 | 1 | 0.2% |
| 3112.21 | 1 | 0.2% |
| 4780.77 | 1 | 0.2% |
| 9505.49 | 1 | 0.2% |
| 10830.44 | 1 | 0.2% |
| 15034.15 | 1 | 0.2% |
| 17539.41 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 24982823.48 | 1 | |
| 23730069.38 | 1 | |
| 20787921.15 | 1 | |
| 20627810.78 | 1 | |
| 19885808.24 | 1 | |
| 17249020.38 | 1 | |
| 16207465.22 | 1 | |
| 15743573.5 | 1 | |
| 15631281.7 | 1 | |
| 15449270.92 | 1 |
beneficiary_cost_share_no_lis
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 276 |
|---|---|
| Distinct (%) | 93.9% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41548691 |
| Minimum | 0 |
|---|---|
| Maximum | 3.7454264 × 108 |
| Zeros | 19 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2531342.9 |
| median | 13354509 |
| Q3 | 40321755 |
| 95-th percentile | 1.8214768 × 108 |
| Maximum | 3.7454264 × 108 |
| Range | 3.7454264 × 108 |
| Interquartile range (IQR) | 37790412 |
Descriptive statistics
| Standard deviation | 67263523 |
|---|---|
| Coefficient of variation (CV) | 1.6189084 |
| Kurtosis | 6.4345253 |
| Mean | 41548691 |
| Median Absolute Deviation (MAD) | 12029032 |
| Skewness | 2.4204238 |
| Sum | 1.2215315 × 1010 |
| Variance | 4.5243816 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 31255332.42 | 1 | 0.2% |
| 152539250.2 | 1 | 0.2% |
| 915495.6 | 1 | 0.2% |
| 1761959.46 | 1 | 0.2% |
| 468831.45 | 1 | 0.2% |
| 14672832.69 | 1 | 0.2% |
| 33830.27 | 1 | 0.2% |
| 90017704.75 | 1 | 0.2% |
| 180156162.5 | 1 | 0.2% |
| Other values (266) | 266 | |
| (Missing) | 282 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 27868.45 | 1 | 0.2% |
| 33830.27 | 1 | 0.2% |
| 230364.44 | 1 | 0.2% |
| 275824.96 | 1 | 0.2% |
| 281066.46 | 1 | 0.2% |
| 333503.38 | 1 | 0.2% |
| 374583.58 | 1 | 0.2% |
| 390428.09 | 1 | 0.2% |
| 400618.96 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 374542642.5 | 1 | |
| 370273860.1 | 1 | |
| 355047463.8 | 1 | |
| 331466334.3 | 1 | |
| 270949753.5 | 1 | |
| 237177177.4 | 1 | |
| 219440128.4 | 1 | |
| 206346787.7 | 1 | |
| 203452124.7 | 1 | |
| 200403245 | 1 |
average_beneficiary_cost_share_lis
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 264 |
|---|---|
| Distinct (%) | 89.8% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.371361 |
| Minimum | 0 |
|---|---|
| Maximum | 216 |
| Zeros | 19 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7.345 |
| median | 21.465 |
| Q3 | 41.2825 |
| 95-th percentile | 140.237 |
| Maximum | 216 |
| Range | 216 |
| Interquartile range (IQR) | 33.9375 |
Descriptive statistics
| Standard deviation | 44.798235 |
|---|---|
| Coefficient of variation (CV) | 1.1987317 |
| Kurtosis | 2.0961139 |
| Mean | 37.371361 |
| Median Absolute Deviation (MAD) | 14.405 |
| Skewness | 1.6953593 |
| Sum | 10987.18 |
| Variance | 2006.8818 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 21.11 | 2 | 0.3% |
| 24.2 | 2 | 0.3% |
| 116.31 | 2 | 0.3% |
| 25.14 | 2 | 0.3% |
| 7.08 | 2 | 0.3% |
| 7.43 | 2 | 0.3% |
| 21.68 | 2 | 0.3% |
| 20.52 | 2 | 0.3% |
| 8.89 | 2 | 0.3% |
| Other values (254) | 257 | |
| (Missing) | 282 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 0.91 | 1 | 0.2% |
| 1.2 | 1 | 0.2% |
| 1.85 | 1 | 0.2% |
| 1.91 | 1 | 0.2% |
| 2.06 | 1 | 0.2% |
| 2.14 | 1 | 0.2% |
| 2.16 | 1 | 0.2% |
| 2.33 | 1 | 0.2% |
| 2.38 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 216 | 1 | |
| 211.13 | 1 | |
| 178.81 | 1 | |
| 173.57 | 1 | |
| 166.15 | 1 | |
| 163.52 | 1 | |
| 157.02 | 1 | |
| 155.83 | 1 | |
| 154.28 | 1 | |
| 149.76 | 1 |
average_beneficiary_cost_share_no_lis
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 276 |
|---|---|
| Distinct (%) | 93.9% |
| Missing | 282 |
| Missing (%) | 49.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1166.0669 |
| Minimum | 0 |
|---|---|
| Maximum | 8007.22 |
| Zeros | 19 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 58.005 |
| median | 340.465 |
| Q3 | 1689.7775 |
| 95-th percentile | 4227.1795 |
| Maximum | 8007.22 |
| Range | 8007.22 |
| Interquartile range (IQR) | 1631.7725 |
Descriptive statistics
| Standard deviation | 1559.8512 |
|---|---|
| Coefficient of variation (CV) | 1.337703 |
| Kurtosis | 1.7893213 |
| Mean | 1166.0669 |
| Median Absolute Deviation (MAD) | 317.185 |
| Skewness | 1.5511698 |
| Sum | 342823.67 |
| Variance | 2433135.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19 | 3.3% |
| 609.79 | 1 | 0.2% |
| 250.02 | 1 | 0.2% |
| 87.39 | 1 | 0.2% |
| 74.2 | 1 | 0.2% |
| 75.69 | 1 | 0.2% |
| 3076.71 | 1 | 0.2% |
| 1208.22 | 1 | 0.2% |
| 212.45 | 1 | 0.2% |
| 277.13 | 1 | 0.2% |
| Other values (266) | 266 | |
| (Missing) | 282 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 10.96 | 1 | 0.2% |
| 11.18 | 1 | 0.2% |
| 11.84 | 1 | 0.2% |
| 11.88 | 1 | 0.2% |
| 12.1 | 1 | 0.2% |
| 12.38 | 1 | 0.2% |
| 13.46 | 1 | 0.2% |
| 14.53 | 1 | 0.2% |
| 15.54 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 8007.22 | 1 | |
| 6836.69 | 1 | |
| 6129.72 | 1 | |
| 5655.3 | 1 | |
| 5553.34 | 1 | |
| 5497.09 | 1 | |
| 5204.8 | 1 | |
| 5120.22 | 1 | |
| 5053.61 | 1 | |
| 5028.09 | 1 |
serialid
Real number (ℝ)
UNIFORM  UNIQUE 
| Distinct | 576 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 288.5 |
| Minimum | 1 |
|---|---|
| Maximum | 576 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29.75 |
| Q1 | 144.75 |
| median | 288.5 |
| Q3 | 432.25 |
| 95-th percentile | 547.25 |
| Maximum | 576 |
| Range | 575 |
| Interquartile range (IQR) | 287.5 |
Descriptive statistics
| Standard deviation | 166.42115 |
|---|---|
| Coefficient of variation (CV) | 0.57684975 |
| Kurtosis | -1.2 |
| Mean | 288.5 |
| Median Absolute Deviation (MAD) | 144 |
| Skewness | 0 |
| Sum | 166176 |
| Variance | 27696 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | 0.2% |
| 2 | 1 | 0.2% |
| 381 | 1 | 0.2% |
| 382 | 1 | 0.2% |
| 383 | 1 | 0.2% |
| 384 | 1 | 0.2% |
| 385 | 1 | 0.2% |
| 386 | 1 | 0.2% |
| 387 | 1 | 0.2% |
| 388 | 1 | 0.2% |
| Other values (566) | 566 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 576 | 1 | |
| 575 | 1 | |
| 574 | 1 | |
| 573 | 1 | |
| 572 | 1 | |
| 571 | 1 | |
| 570 | 1 | |
| 569 | 1 | |
| 568 | 1 | |
| 567 | 1 |
| year | total_spending | beneficiary_count | unit_count | beneficiary_cost_share | total_annual_spending_per_user | average_cost_per_unit | average_annual_beneficiary_cost_share | claim_count | beneficiary_cost_share_lis | beneficiary_cost_share_no_lis | average_beneficiary_cost_share_lis | average_beneficiary_cost_share_no_lis | serialid | coverage_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| year | 1.000 | 0.278 | 0.130 | 0.125 | 0.201 | 0.235 | 0.198 | 0.193 | 0.127 | 0.116 | 0.229 | 0.138 | 0.208 | 0.003 | 0.000 |
| total_spending | 0.278 | 1.000 | 0.376 | 0.390 | 0.860 | 0.538 | 0.488 | 0.568 | 0.474 | 0.781 | 0.893 | 0.620 | 0.523 | 0.018 | 0.212 |
| beneficiary_count | 0.130 | 0.376 | 1.000 | 0.667 | 0.359 | -0.409 | -0.210 | -0.526 | 0.953 | 0.852 | 0.624 | -0.187 | -0.350 | -0.335 | 0.241 |
| unit_count | 0.125 | 0.390 | 0.667 | 1.000 | 0.463 | -0.135 | -0.432 | 0.174 | 0.760 | 0.752 | 0.544 | -0.183 | -0.351 | -0.248 | 0.347 |
| beneficiary_cost_share | 0.201 | 0.860 | 0.359 | 0.463 | 1.000 | 0.469 | 0.340 | 0.552 | 0.453 | 0.859 | 0.999 | 0.518 | 0.331 | 0.001 | 0.285 |
| total_annual_spending_per_user | 0.235 | 0.538 | -0.409 | -0.135 | 0.469 | 1.000 | 0.764 | 0.999 | -0.302 | 0.010 | 0.311 | 0.890 | 0.982 | 0.243 | 0.286 |
| average_cost_per_unit | 0.198 | 0.488 | -0.210 | -0.432 | 0.340 | 0.764 | 1.000 | 0.466 | -0.226 | 0.056 | 0.314 | 0.821 | 0.930 | 0.217 | 0.121 |
| average_annual_beneficiary_cost_share | 0.193 | 0.568 | -0.526 | 0.174 | 0.552 | 0.999 | 0.466 | 1.000 | -0.334 | NaN | NaN | NaN | NaN | 0.402 | 1.000 |
| claim_count | 0.127 | 0.474 | 0.953 | 0.760 | 0.453 | -0.302 | -0.226 | -0.334 | 1.000 | 0.893 | 0.655 | -0.121 | -0.288 | -0.333 | 0.341 |
| beneficiary_cost_share_lis | 0.116 | 0.781 | 0.852 | 0.752 | 0.859 | 0.010 | 0.056 | NaN | 0.893 | 1.000 | 0.844 | 0.208 | 0.044 | -0.227 | 1.000 |
| beneficiary_cost_share_no_lis | 0.229 | 0.893 | 0.624 | 0.544 | 0.999 | 0.311 | 0.314 | NaN | 0.655 | 0.844 | 1.000 | 0.528 | 0.342 | -0.065 | 1.000 |
| average_beneficiary_cost_share_lis | 0.138 | 0.620 | -0.187 | -0.183 | 0.518 | 0.890 | 0.821 | NaN | -0.121 | 0.208 | 0.528 | 1.000 | 0.921 | 0.152 | 1.000 |
| average_beneficiary_cost_share_no_lis | 0.208 | 0.523 | -0.350 | -0.351 | 0.331 | 0.982 | 0.930 | NaN | -0.288 | 0.044 | 0.342 | 0.921 | 1.000 | 0.165 | 1.000 |
| serialid | 0.003 | 0.018 | -0.335 | -0.248 | 0.001 | 0.243 | 0.217 | 0.402 | -0.333 | -0.227 | -0.065 | 0.152 | 0.165 | 1.000 | 0.319 |
| coverage_type | 0.000 | 0.212 | 0.241 | 0.347 | 0.285 | 0.286 | 0.121 | 1.000 | 0.341 | 1.000 | 1.000 | 1.000 | 1.000 | 0.319 | 1.000 |
| year | brand_name | generic_name | coverage_type | total_spending | beneficiary_count | unit_count | beneficiary_cost_share | total_annual_spending_per_user | average_cost_per_unit | average_annual_beneficiary_cost_share | claim_count | beneficiary_count_lis | beneficiary_count_no_lis | beneficiary_cost_share_lis | beneficiary_cost_share_no_lis | average_beneficiary_cost_share_lis | average_beneficiary_cost_share_no_lis | serialid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2010 | Abilify | Aripiprazole | Part D | 1.225885e+09 | 338626 | 71848190 | 38186677.97 | 3620.17 | 17.06 | NaN | 2296081 | 287,370 | 51,256 | 6931345.55 | 31255332.42 | 24.12 | 609.79 | 1 |
| 1 | 2011 | Abilify | Aripiprazole | Part D | 1.469590e+09 | 360670 | 77471756 | 33752894.08 | 4074.61 | 18.97 | NaN | 2447867 | 303,264 | 57,406 | 7000137.54 | 26752756.54 | 23.08 | 466.03 | 2 |
| 2 | 2012 | Abilify | Aripiprazole | Part D | 1.758054e+09 | 376601 | 82161700 | 39700089.43 | 4668.21 | 21.40 | NaN | 2572017 | 310,592 | 66,009 | 6594393.26 | 33105696.17 | 21.23 | 501.53 | 3 |
| 3 | 2013 | Abilify | Aripiprazole | Part D | 2.107092e+09 | 396764 | 86150300 | 46564692.85 | 5310.69 | 24.46 | NaN | 2886837 | 317,698 | 79,066 | 6872985.09 | 39691707.76 | 21.63 | 502.01 | 4 |
| 4 | 2014 | Abilify | Aripiprazole | Part D | 2.527319e+09 | 405161 | 88198691 | 49598419.68 | 6237.83 | 28.65 | NaN | 2964075 | 326,791 | 78,369 | 6334112.63 | 43264307.05 | 19.38 | 552.06 | 5 |
| 5 | 2015 | Abilify | Aripiprazole | Part D | 1.572428e+09 | 322582 | 47855047 | 32007792.27 | 4874.51 | 33.12 | NaN | 1635610 | 269,558 | 53,024 | 4447124.49 | 27560667.78 | 16.50 | 519.78 | 6 |
| 6 | 2010 | Abraxane | Paclitaxel Protein-Bound | Part B | 1.155539e+08 | 6811 | 12379531 | 22795393.66 | 16965.78 | 9.33 | 3346.85 | 54260 | NaN | NaN | NaN | NaN | NaN | NaN | 7 |
| 7 | 2011 | Abraxane | Paclitaxel Protein-Bound | Part B | 1.213891e+08 | 7660 | 12919123 | 24065171.49 | 15847.14 | 9.40 | 3141.67 | 55813 | NaN | NaN | NaN | NaN | NaN | NaN | 8 |
| 8 | 2012 | Abraxane | Paclitaxel Protein-Bound | Part B | 1.341285e+08 | 8392 | 14085125 | 26648986.33 | 15982.90 | 9.52 | 3175.52 | 60473 | NaN | NaN | NaN | NaN | NaN | NaN | 9 |
| 9 | 2013 | Abraxane | Paclitaxel Protein-Bound | Part B | 2.130076e+08 | 14091 | 22660310 | 42963406.52 | 15116.57 | 9.40 | 3049.00 | 97001 | NaN | NaN | NaN | NaN | NaN | NaN | 10 |
| year | brand_name | generic_name | coverage_type | total_spending | beneficiary_count | unit_count | beneficiary_cost_share | total_annual_spending_per_user | average_cost_per_unit | average_annual_beneficiary_cost_share | claim_count | beneficiary_count_lis | beneficiary_count_no_lis | beneficiary_cost_share_lis | beneficiary_cost_share_no_lis | average_beneficiary_cost_share_lis | average_beneficiary_cost_share_no_lis | serialid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 566 | 2012 | Yervoy | Ipilimumab | Part B | 1.939894e+08 | 2101 | 1551476 | 20707885.01 | 92331.93 | 125.04 | 9856.20 | 6126 | NaN | NaN | NaN | NaN | NaN | NaN | 567 |
| 567 | 2013 | Yervoy | Ipilimumab | Part B | 2.166421e+08 | 2349 | 1730977 | 22259232.46 | 92227.37 | 125.16 | 9476.05 | 6701 | NaN | NaN | NaN | NaN | NaN | NaN | 568 |
| 568 | 2014 | Yervoy | Ipilimumab | Part B | 2.653790e+08 | 2881 | 2059976 | 27560982.18 | 92113.50 | 128.83 | 9566.46 | 8026 | NaN | NaN | NaN | NaN | NaN | NaN | 569 |
| 569 | 2015 | Yervoy | Ipilimumab | Part B | 2.171237e+08 | 2340 | 1628713 | 22027616.51 | 92787.90 | 133.31 | 9413.51 | 6326 | NaN | NaN | NaN | NaN | NaN | NaN | 570 |
| 570 | 2010 | Zytiga | Abiraterone Acetate | Part D | 0.000000e+00 | 0 | 0 | 0.00 | 0.00 | 0.00 | NaN | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 571 |
| 571 | 2011 | Zytiga | Abiraterone Acetate | Part D | 7.100941e+07 | 3936 | 1648304 | 6346405.33 | 18041.01 | 43.08 | NaN | 13477 | 987 | 2,949 | 50177.15 | 6296228.18 | 50.84 | 2135.04 | 572 |
| 572 | 2012 | Zytiga | Abiraterone Acetate | Part D | 2.242602e+08 | 8357 | 4594078 | 16650258.05 | 26835.01 | 48.82 | NaN | 37934 | 2,105 | 6,252 | 216616.82 | 16433641.23 | 102.91 | 2628.54 | 573 |
| 573 | 2013 | Zytiga | Abiraterone Acetate | Part D | 4.696617e+08 | 14191 | 8630869 | 27858755.39 | 33095.74 | 54.42 | NaN | 71423 | 3,327 | 10,864 | 312215.67 | 27546539.72 | 93.84 | 2535.58 | 574 |
| 574 | 2014 | Zytiga | Abiraterone Acetate | Part D | 7.070979e+08 | 17044 | 11836159 | 41003957.93 | 41486.61 | 59.74 | NaN | 98469 | 3,585 | 13,459 | 472187.38 | 40531770.55 | 131.71 | 3011.50 | 575 |
| 575 | 2015 | Zytiga | Abiraterone Acetate | Part D | 7.900497e+08 | 16965 | 12022089 | 44876300.01 | 46569.39 | 65.72 | NaN | 100376 | 3,541 | 13,424 | 579011.31 | 44297288.70 | 163.52 | 3299.86 | 576 |